home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vcboxcycle.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
58 lines
/*
forms a union of the 4 types of actions for a cashbox: insert, probe, remove, count
in the report they are arranged by date and time.
*/
create or replace view vcboxcycle as
select 'Insert ' type, 1 rectype,
cbinsert.conv_date,
cbinsert.cashbox_glid cbox,
cbinsert.farebox_glid fbox,
sysdate probe_insert,
' ' flag,
' ' pull ,
0 probedcash,
0 totalcash,
0 total,
sysdate systemdate
from cbinsert
union
select ' Remove ', 3 rectype,
cbremov.conv_date,
cbremov.cashbox_glid cbox,
cbremov.farebox_glid fbox,
sysdate probe_insert,
' ' flag,
' ' pull ,
0 probedcash,
0 totalcash,
0 total,
sysdate systemdate
from cbremov
union
select ' Probe ', 2 rectype, pdate,
cashbox_glid cbox,
farebox_glid fbox,
insert_date,
'<-----' flag,
decode(pull, 1, 'Yes', 'No ') pull ,
probedcash,
totalcash,
0 total,
sysdate systemdate
from vbusprobe50
union
select ' Count', 4 rectype,
count_date,
cashbox_glid cbox,
-1 fbox,
sysdate probe_insert,
'----->' flag,
' ' pull ,
0 probedcash,
0 totalcash,
total,
sysdate systemdate
from vcbcount;